﻿CREATE TABLE [dbo].[TabExtMailSetting] (
    [ID]             int          NOT NULL identity(1, 1),
    [Username]       nvarchar(50)  COLLATE Chinese_PRC_CI_AS NOT NULL,
    [Title]          nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [Email]          nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL,
    [SmtpAuth]       bit          NULL,
    [SmtpServer]     nvarchar(64)  COLLATE Chinese_PRC_CI_AS NULL,
    [SmtpUsername]   nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
    [SmtpPassword]   nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
    [SmtpPort]       smallint     NULL,
    [PopServer]      nvarchar(64)  COLLATE Chinese_PRC_CI_AS NULL,
    [PopUsername]    nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
    [PopPassword]    nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
    [PopPort]        smallint     NULL,
    [IsDelAfterRead] bit          NULL,
    [IsReceiveNew]   bit          NULL,
    [TimeOut]        nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [OrderID]        int          NULL
);
GO
